#1.平台游戏数量分布
sqoop export --connect "jdbc:mysql://172.56.52.170:3306/project?serverTimezone=GMT%2B8&characterEncoding=utf8" \
--username work \
--password 123456 \
--driver com.mysql.cj.jdbc.Driver \
--table ads_steam_games_platform_cnt  -hcatalog-database project \
--hcatalog-table ads_steam_games_platform_cnt

#2.每年的新游戏
sqoop export --connect "jdbc:mysql://172.56.52.170:3306/project?serverTimezone=GMT%2B8&characterEncoding=utf8" \
--username work \
--password 123456 \
--driver com.mysql.cj.jdbc.Driver \
--table ads_steam_games_year_cnt  -hcatalog-database project \
--hcatalog-table ads_steam_games_year_cnt
#3.游戏特征词云图
sqoop export --connect "jdbc:mysql://172.56.52.170:3306/project?serverTimezone=GMT%2B8&characterEncoding=utf8" \
--username work \
--password 123456 \
--driver com.mysql.cj.jdbc.Driver \
--table ads_steam_games_tags_cnt  -hcatalog-database project \
--hcatalog-table ads_steam_games_tags_cnt

#4.前20的开发商
sqoop export --connect "jdbc:mysql://172.56.52.170:3306/project?serverTimezone=GMT%2B8&characterEncoding=utf8" \
--username work \
--password 123456 \
--driver com.mysql.cj.jdbc.Driver \
--table ads_steam_games_developer_cnt  -hcatalog-database project \
--hcatalog-table ads_steam_games_developer_cnt

#5.前20的出版商
sqoop export --connect "jdbc:mysql://172.56.52.170:3306/project?serverTimezone=GMT%2B8&characterEncoding=utf8" \
--username work \
--password 123456 \
--driver com.mysql.cj.jdbc.Driver \
--table ads_steam_games_publisher_cnt  -hcatalog-database project \
--hcatalog-table ads_steam_games_publisher_cnt

#6.游戏价格分布
sqoop export --connect "jdbc:mysql://172.56.52.170:3306/project?serverTimezone=GMT%2B8&characterEncoding=utf8" \
--username work \
--password 123456 \
--driver com.mysql.cj.jdbc.Driver \
--table ads_steam_games_price_cnt  -hcatalog-database project \
--hcatalog-table ads_steam_games_price_cnt

#7.每种游戏的好评率、差评率
sqoop export --connect "jdbc:mysql://172.56.52.170:3306/project?serverTimezone=GMT%2B8&characterEncoding=utf8" \
--username work \
--password 123456 \
--driver com.mysql.cj.jdbc.Driver \
--table ads_steam_games_category_cnt  -hcatalog-database project \
--hcatalog-table ads_steam_games_category_cnt

#8.游戏年龄要求情况
sqoop export --connect "jdbc:mysql://172.56.52.170:3306/project?serverTimezone=GMT%2B8&characterEncoding=utf8" \
--username work \
--password 123456 \
--driver com.mysql.cj.jdbc.Driver \
--table ads_steam_games_age_cnt  -hcatalog-database project \
--hcatalog-table ads_steam_games_age_cnt